---
title: ClickHouse
---

<Tip>
**Compatibility**

Only available on Node.js.
</Tip>

[ClickHouse](https://clickhouse.com/) is a robust and open-source columnar database that is used for handling analytical queries and efficient storage, ClickHouse is designed to provide a powerful combination of vector search and analytics.

## Setup

1. Launch a ClickHouse cluster. Refer to the [ClickHouse Installation Guide](https://clickhouse.com/docs/en/getting-started/install/) for details.
2. After launching a ClickHouse cluster, retrieve the `Connection Details` from the cluster's `Actions` menu. You will need the host, port, username, and password.
3. Install the required Node.js peer dependency for ClickHouse in your workspace.

You will need to install the following peer dependencies:

```bash npm
npm install -S @clickhouse/client mysql2
```
import IntegrationInstallTooltip from '/snippets/javascript-integrations/integration-install-tooltip.mdx';

<IntegrationInstallTooltip/>

```bash npm
npm install @langchain/openai @langchain/community @langchain/core
```

## Index and Query Docs

import ClickhouseFromtexts from "/snippets/javascript-integrations/examples/indexes/vector_stores/clickhouse_fromTexts.mdx";

<ClickhouseFromtexts />

## Query Docs From an Existing Collection

import ClickhouseSearch from "/snippets/javascript-integrations/examples/indexes/vector_stores/clickhouse_search.mdx";

<ClickhouseSearch />

## Related

- Vector store [conceptual guide](/oss/concepts/#vectorstores)
- Vector store [how-to guides](/oss/how-to/#vectorstores)
